Mac Format 1997 January

home *** CD-ROM | disk | FTP | other *** search

/ Mac Format 1997 January / macformat46.iso / File Maker Pro 3.0 Tutorial / File Maker Pro 3.0 / Templates / FileMaker Templates / Template Information (.txt) < prev

Wrap

FileMaker Pro Database | 1996-06-20 | 308KB | 3,416 lines

TPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKTPKKT HBAM2016AUG95 Pro 3.0 u".Cw u".Cw item@ print@ spending@ HBAM3016AUG95@ addresses] album` applicationW assetA asset managementA badgesV comparisonB billingse brochurea budgetsT businessC business cardsC versus leaseD cardsC cashE receiptsE cellarh certificates chequeG cheque trackerG clubH membershipH collection comparisonB coverP databaseS employeeJ employee leave formsJ equipmentK equipment rental usageK eventL event scheduleL expenseM expense reportM expensesj expenses systemj facultyN faculty staffN familyO family medical recordsO cover sheetsP fieldQ field tripsQ filmR video libraryR flyerS formsJ frequentS frequent flyer databaseS homeT budgetsT inventoryU identificationV identification badgesV inventoryU inventory systemk applicationW searchX recordsI Asset Management Description This file helps you track office assets such as furniture, equipment, or any other depreciable item. The file includes fields to input the serial number and purchase date of the asset. How to use this template You can print an inventory report that you can use to complete your taxes. How to customise this template The Item, Location, Assigned To, and Purchased From fields use value lists based on the their own contents. This means that every time you add a new value in any o f those fields, the value is added to the pop-up list for the field, making it easier to enter that value in the future. The Category pop-up menu is based on a pre-defined value list. To edit the value list, select the Category field in the Form View layout in Layout mode. Choose Field Format from the Format menu. In the pop-up menu of value lists, choose Define Value List , and edit the list of categories. Business Templates 6/20/96 ABOUT TEXT CATEGORY CREATED BY DATE CREATED DATE MODIFIED DESCRIPTION KEYWORDS LASTLAYOUTNUMBER G MAIN MENU INFO SOLUTION ID SOLUTION NAME Solution NameB DescriptionB KeywordsB Date CreatedB Date ModifiedB Solution IDB InfoB Created ByB Included with FileMaker Pro is a collection of templates to help you begin using the product quickly. These templates are designed as solutions for either business, education, or home use and may give you new ideas about how to use FileMaker Pro. All templates are available on the FileMaker Pro CD installation, with a reduced set included on the floppy disk installation. To create a database using a template, select a template from the New Database dialog box that appears when you start FileMaker Pro or choose New from the File menu. FileMaker Pro makes a copy of the original template and opens the copy for you to use. Modifications are then made to the new database, not the original template. To open a database you have created, select Open from the File menu and select the desired file. Template Usage Layouts Each layout has been designed to fit a Macintosh 14" or Windows 640x480 VGA screen. Layouts such as Form View, List View, Information, and Reports can be acces About TextB CategoryB Main Menu InfoB LastLayoutNumber gB Details Information About Print Template Information Print Information ListB wwwwww UUUUUU DDDDDD """""" s the Information layout, click the Info button in the button bar. This layout contains a brief description of the file, an explanation of how t ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 o perform a common task. For example, you may want to create a button that prints the current record. To define a Print button: 1. Choose Layou to create a button that finds all your contacts in California, sorts them by Last Name, and prints a repor Choose Browse from the wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 Proctor, Jamie Pruden, Don Ross, Bill Shissler, Joanna Terry, and the entire FileMaker team. ur own needs. Just add or modify fi king with FileMaker Pro files. Select a category of templates from the buttons provided to see an overview of the FileMaker Pro templates and what they can do for you! To create a database using a template, select a template from the New Database dialog box that appears when you start FileMaker Pro or ch !oose New from the File menu. FileMaker Pro makes a copy of the original template and opens the copy for you to use. Modifications are then made to the new database, not the original template. To open a database you have created, select Open from the File menu and select the desired file. MenuB Yesfter Noarter Template Nameg,Click to see more information for a templateh Templatek Template Listl Template Detailsm Menun Closeo Infos Categoryw Keywords| Database...} Print DetailsB TemplateH MenuI CloseJ TemplateH MenuI CloseJ K6Click a button to view the Templates for that categoryM BusinessN EducationO HomeR Template InformationT About...V Template InformationB Keyword(s) Template Name Database... Template Template Template Details Close r"FileMaker Pro Template Information Category Print mplate Template Details Close r"FileMaker Pro Template Information Category Print AboutB Yesfter Noarter N!Using the FileMaker Pro TemplatesO Template ListP Template DetailsQ MenuR CloseS InfoT!Using the FileMaker Pro TemplatesY Print Print Template InformationB Yesfter Noarter Yesfter Noarter Template ListP Template DetailsQ MenuR CloseS InfoT!About the FileMaker Pro TemplatesX About...[ About...] Return Print InformationB Yesfter Noarter Yesfter Noarter "FileMaker Pro Template Information Page ## Template Information Return Category: Keywords: FindB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter A!Using the FileMaker Pro TemplatesB"FileMaker Pro Template InformationE ReturnG Template InformationH Page ##I Template - FindB Keyword:C!Enter find criteria and click OK:E Description:I Template Name:O Category:R Home Templates Education Templates C Education Open Script .A Show Menu Sort by Category Sort by Keywords 2A List View 3A Form View 6A Show Info Show About 9A%Print Template Information with Error Business Cancel No Records to Print.C) Current Found Set> Canceln Cg,$K5C Print detail information for all of the templates in this found set or just the current template?E) HP DeskJet 540 Printer Set Field for Last Layout Page Set up for Current Record HP DeskJet 540 Printer <A#Toggle Status Area (Debug Use Only) Print Information with Error Cancel No Records to Print. Page Set up for Found Set HP DeskJet 540 Printer Find with Error HP DeskJet 540 Printer All Templates C read only Business )=400) Cancel *You did not enter any find criteria. All records will be displayed.C) OKrrent Found Set> Canceln Cg,$K5C No Templates match this request.E) #Toggle Status Area (Debug Use Only) Open Script Find with Error Show Menu List View Form View Show Info Show About Sort by Solution Name Sort by Category Sort by Keywords Business Templates Education Templates Home Templates All Templates *%Print Template Information with Error Print Information with Error Page Set up for Current Record Page Set up for Found Set Set Field for Last Layout Sort by Solution Name Business Templates ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" lease@ tracker@ affect@ automatically@ borrower@ certificates@ cover@ deposit@ determine@ different@ earned@ entertaining@ feature@ form@ template@ import@ ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" UUUUU wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" -4 4 :43:4::44 4 . d^^44 :44::4:94 - ]^::44: 4 75 ]9^ccd ]99dcd cd]]3^ ]^c^cddc 4]44: d^c^c 3. 43 c^d:4 4(]]4:]44]dd^cdc 44]4:^c 75+ 4:4:4 4 3W 4^:^4: . 7#+ ]4 44 : 4X:4 4:4 4:^^] 2^^43 4^^::44 3^d9:44 4 ]4 4::d]43^ 3. 43 4 443 ^ ::4 :44]4 :4 ^X +,4 44:4 4 .]3 4:94 +2 443 4:9X49 44:44 4]4 4 4:^d4 : :^:]:4 ]4 3]4 4 3 43 44344 B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" wwwwww ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" g9g9Ns g9g9^ ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" (LIST VDEFA( (LIST VDEFA( Category ListE Template List Bg9g9^ g9g9^ g9g9^ g9g9^ 9g9o{F1 g9g9V g9g99 g9g9^ g9g9V Bg9g9^ g9g9^ g9g9^ Nsg9g9o{^ o{g9g9^ g9g99 g9g9)J F1g9g9^ )Jg9g9^ g9g9V g9g9^ F1g9g9)J g9g9^ g9g9o{ g9g9^ g9g9^ o{Ns1 g9g9Ns g9g99 g9g9F1 g9g9Ns g9g9^ g9g9^ g9g9o{ g9g9^ g9g9^ Nsg9g9^ g9g9o{ g9g9o{ g9g91 g9g9V Nsg9g9^ BNsg9Ns Nsg9^ g9g9Ns o{g9g99 o{F19 Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Helvetica Times Palatino Chicago Geneva Monaco Courier New York Helvetica Black Helvetica Compressed H Futura Heavy Times New Roman Arial MS Sans Serif Arial MT Condensed Light Avant Garde Bodoni Book N Helvetica Narrow L Futura Light Futura MdIt BT 10/3/95{ 29/5/96 Paul Farrah Business Bid Comparison Description Use this database to organise information when entertaining multiple bids on a project. How to use this template For each project, enter as much information as you have about each company's bid. Use the Bid Comparison report to organise the information to make it easy to compare the bids to each other. How to customise this template Define additional fields that will help you differentiate the bids. For instance, for a landscape bid, you might want to know whether or not thB e company offers a landscape maintenance service. You can add a field called Maintenance and display it as a check box or Yes/No radio buttons. y"Asset Management, Office Inventory y"Asset Management, Office Inventory itemA itemsI jewelleryU justE keepE keepingd keepsF knowB label] labels] landscapeB lastJ layoutA layoutsC leaseD leaveJ leaves[ letterX lettersd levels\ libraryR like` linea linkK linkedK nextH numberA numbersH offersB officeA onceF onlyF orderK organiseB otherA overdueK pageC pasteC pauseF paymentsD peopleF performsD personF personalH personnelJ phoneH pieceK pop-upA pre-definedA predefinedK prepareE presentD previewE printA printing] printsC priorityf producta productivitye productsa professionalV profiles] profit-margina progressd projectB projectse proposale protocol[ providedV providerO providersO providesP purchaseA purchasedA purposesV quicklyC quicktime` radioB rateM ratherM ratingg ready` receiptE receiptsE receivablee receiveS received^ recipesc recipientF recordF valuesD viewA wantB whenB whetherB whichE willB withD yearsD yes/noB yourA addressesC assetA asset management office inventoryA comparison projectsB lease managementD cardsC cards names addressesC cashE managementA medicalO membershipH memorandumZ messages[ messages telephone[ mileageS music\ namesC names rolodex] officeA ordersb organisationf party^ payrolll personnel_ photographyR planningT producta projecti project management trackingi HP DeskJet 540 Printer Pro 1.0F! Pro 3.0J t US Letter A4 Letter US Legal International Fanfold Computer Paper Envelope (#10) els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12345M1 Bid Comparison, Projectsz 6/3/95{ 29/5/96 Paul Farrah Business Business Cards Description Use this database to create business cards quickly and easily. How to use this template Type the information into the fields and paste or import the logo. The Business Cards report layout prints ten business cards per page. How to customise this template Create new layouts to make different styles of cards. You can do this easily by duplicating the Business Cards layout and then editing the look of the graphics and text. Cards, Names, Addressesz 13/3/95{ 29/5/96 Paul Farrah Business Buy versus Lease 29/5/96{ 29/5/96 Lorraine Smith differentC differentiateB digitalV directlyJ discountb discountsb discs\ dishc disk` displayB distanceQ doctorO documentationE does] dollarT dollsI don'tF double-clickM downD duplicateV duplicatingC durationl duringe eachB rnedS easierA easilyC easyB editA editingC educationW effectiveT eitherN elementaryd eliminatingY emailH emergencyN employeeJ employee's_ employeesJ employere enterA enter information fields yourI enter frequent flyer transactions enteringS Business asset management comparison business cards versus lease receipts membership collection employee leave forms equipment rental usage expense report expenses system cover sheets frequent flyer database identification badges inventory system application messages names addresses personnel records product brochure projects system purchase orders service billings timecards addresses party wedding planning personnel records photo album product brochure projects system purchase orders recipes student records service billings timecards video database cellar 13/3/95{ 29/5/96 Paul Farrah Business Cash Receipts Description Use this database to keep track of those hard-to-manage cash receipts. Just enter your receipt information on a regular basis to make it easier to organise your financial records. How to use this template Enter in your information and print a cash receipts report, which you can use to prepare your taxes. How to customise this template Edit the Category list to reflect your needs. To edit the list, select the Category field in the Form View layout in Layout mode. Choose Field Format from the Format menu. In the Value List pop-up menu (that currently says "Category List"), choose Define Value List , and add or delete values. Create a new report that sorts the receipts by category. To do this, simply use the Receipt Summary layout, sort by Category and select Preview from the Layout menu. For details on sorting and preview, see the FileMaker Pro documentation. Lorraine Smith Description You can use this file to analyse relative costs and determine whether to buy or lease an item. Enter the data and the database performs the calculations. How to use this template Experiment with different down payments or loan/lease terms (in years) to see how changes in those values can affect your decision. How to customise this template Present the information graphically by exporting the data from the file and using it to create a chart in ClarisWorks or ClarisImpact. Buy, Lease Management 29/5/96 Paul Farrah Business Certificates Description Use this database to create certificates and awards. The database then keeps track of all the certificates you have created. How to use this template To create a certificate that will be used only once, enter information into all the fields in the Individual Recipient layout. Then view the finished certificate by clicking the Report button and then choosing the For Individual report. If you want to create copies of the same basic certificate for many people, you don't need t 29/5/96{ 29/5/96 Lorraine Smith Cash, Expenses, Receiptsz 5/4/95 expenses receiptsE cellarh certificatesF chequeG clubH membership names subscriptionH coinsI collectionI collection coins stamps libraryI comparisonB controlk cookingc cooking recipesc ndence letter generation memorandumZ dataa doctorO doctor family medicalO employeeJ employee management expenseM employee management faculty staffN employee management leave vacationJ employee management personnel_ employmentW equipmentK equipment library loans school administrationY equipment rentalK event^ event management party planning wedding^ eventsL expenseM expensesE facsimileP facultyN familyO fieldQ field trips school administration studentsQ filmR library photography videoR financeG generationZ homeU insuranceU inventoryA search employmentX leaseD leaveJ letterZ libraryI loansY 10/3/95{ 29/5/96 Paul Farrah C Education Cheque Tracker Description This is a simple template to record debits from and credits to a cheque account. The Transaction List report calculates your running balance. How to use this template Enter all your transactions as you write checks and withdraw or deposit money. Include the check number or transaction number in the Ref. No. field as a reference. How to customise this template Add a new field called Category. Then, you can design a report that breaks down your financial transactions by cB}ategory, so that you know where your money goes each month. See the documentation on Subsummary reports for more information. y#Banking, Cheque, Finance, Balancingz 9/6/95{ 29/5/96 Paul Farrah Club Membership 29/5/96{ 29/5/96 Lorraine Smith o enter all the information for each person. Instead, click the Multiple Recipient button to go to the Multiple Recipient layout. Enter the basic information once, and it will be repeated for each new record. How to customise this template In Layout mode, create new layouts for your own certificates and awards. See the FileMaker Pro documentation for information on using global fields, such as those used in the Multiple Recipient entry form and certificate. Add buttons for each new c ?ertificate design in the Report menu. You can change the Report scripts so that they print the current Found Set. To do so, edit the For Individual and For Many scripts in Script Maker : remove the Pause after the Preview Mode step and insert a Print step. For more information, see the documentation for Script Maker. Awards, Certificates certificatesF changeF changesD changingT chartD checkB checksG chequeG child'sd children's] chooseA choosingF chosen[ claimU clarisimpactD clarisworksD classroomd clickF clickingF clipboardV clothingU clubH coinI collectW collectionI column^ combinea comingH commentg commentsg compact\ companyB company'sB compareB comparesH comparisonB completeA computer` computersK conditionO connectionsd considera consistsi contactN contactsP containa container\ containsK contentsA controlT convertV coordinateR copiesF copyV copyingW costi costsD couldK counti couple^ detailsE determineD diagnosisO diallingN recordsE redeemS reducedk referenceG referencesW reportA runningG sameF saysE scriptF scriptsF selectA serialA serviceB simpleG simplyE sortE sortingE sortsE stepF stylesC suchA summaryE taxesA templateA termsD textC thatA theirA thenC theyF thisA thoseA timeA trackA transactionG transactionsG typeC database track those hard-to-manage cashE usedF usingD valueA valuesD viewA wantB whenB whetherB whichE willB withD withdrawG writeG yearsD yes/noB yourA addressesC assetA asset management office inventoryA awardsF awards certificatesF badgesV badges names tagsV balancingG bankingG banking cheque finance balancingG beveragesh beverages cellar wineh comparison projectsB billinge billing invoicing sales inventory control productk billing invoicing servicee brochurea brochure product sheeta budgetsT budgets finance planningT lease managementD buyingb buying purchase ordersb calendarL calendar eventsL cardsC cards names addressesC cashE reflectE regularE regularlyT reimbursableM reimbursementM relatedj relationJ relationali relationsO relativeD relayingd remainingT remindX remindsH removeF renewalH rentT rentalK rentalsK repeatedF repeatingQ reportA rollR rollsR roomU runningG safeU safe-depositU salaryN sameF saveT savingsT saysE scanU scheduleL schoolL screenL scriptF scriptsF scrollingP searchW seekingW selectA sentP separateL serialA serviceB settingN sheetP sheetsP showingK signaturesM simpleG simplyE sitesV skillsW societyV softwareY sortE sortingE sortsE specialX specificU specifyV suchA suitU summarise\ summaryE sunsetd supervisorQ supplierb supplier'sb suppliersb systemK tabsH tagsV take` tapeR tapes\ taskf task'si tasksf taxesA teami telephone_ templateA termsD textC thanM thankX thatA theyF they'rec thisA database maintains information various field tripsQ helps track rental equipment furnitureK 29/5/96 Paul Farrah Business Collection Description Use this template to keep track of a collection. The database currently keeps track of a coin and stamp collection. How to use this template Enter information into each of the fields as you add to your collection. You can print out a report detailing your collection. How to customise this template Use this database for any collection: books, dolls, and so on. Use the Edit feature in the Item Type pop-up menu to add other items to the value list. y"Collection, Coins, Stamps, Libraryz 22/3/95{ 13/6/96 Paul Farrah Business Employee Leave Forms 29/5/96{ 29/5/96 Lorraine Smith Description Use this file to manage club membership information. Easily keep track of when member's renewal fees are due. How to use this template Use the Membership and Personal tabs to enter and view information about the current member. You can view and print a report of members' phone numbers. How to customise this template Create reports that list members by start date or by company. Add email to the Phone Numbers report. Create a layout that reminds you of upcoming birthdays or aB nniversaries. You can simply find all birthdays in the coming month and display them in a report. Or, you can add a calculation field that compares today's date against the birth date and then create a report of all birthdays in the next 30 days. y%Club, Membership, Names, Subscriptionz 6/3/95 trackerG tripsQ usageK versusD videoR video databaseg wedding^ wineh cellarh ableT aboutB accessV accomplishedi accountG accountinge accountse accuratelyO achieveT acknowledgements^ acquisitionsh actionX activitye information about wines cellarh addedA addingR additionalB addressX addressed^ anytime[ applicantW applicant'sW applicationW areaM areasO arrangedP artifactsU artist\ aspectsQ assessT assetA assetsA assignedA attendanceQ attendees^ entertainingB entryF equipmentA essentialT evenO eventL eventsL everyA examineT exampleT existingV expandablee expenseM expense-trackingM expensesM experienceW experimentD exportingD expositionV extensionM external` facilities` facultyN familyO family'sO favourite\ faxesP futureA globalF goesG graphicallyD graphicsC handJ hard-to-manageE haveB heldL helpB helpsA historyK customise templateI templateE importC includeG includesA individualF informationB inputA insertF instanceB insteadF intoC inventoryA invoicesK item@ list@ location@ modify@ offers@ particular@ payment@ ificates@ expenses receipts@ management@ 29/5/96 Paul Farrah Business Equipment Rental & Usage Description This file helps you track rental equipment, such as furniture or computers. It keeps a rental history for each item. How to use this template Use this template to track current rentals and the rental history of each item. You can run reports detailing overdue rentals and the rental history of each piece. You can also use the reports to complete your taxes. How to customise this template You can change the values in the predefined value list so that the report contains categor Bies for your types of rental equipment. You can link the Customer Order No. field to an Invoices database to complete your tracking system. Or, you can add a Customer ID field linked to a Customers database. Then you could create reports showing which rentals are current and which rentals are overdue for each customer. 29/5/96{ 29/5/96 Lorraine Smith Description Use this file to track employee leave requests. How to use this template Your employees can enter information directly into the database, or create a new, blank record, print it, and complete the form by hand. How to customise this template You can use a relation to your personnel database file based on the Employee ID to enter values for First Name, Last Name, and Department. y$Employee Management, Leave, Vacationz 5/4/95 Equipment, Rentalz 6/3/95{ 29/5/96 Paul Farrah Business Event Schedule Description This database keeps track of events being held at your school. How to use this template Enter the event information in the Form View screen, and then print the Event Schedule report. The report prints each month's events on a separate page. How to customise this template Add your school logo to the layouts. To create a value list for the Location field, select the field on the Form View layout in Layout mode, and choose Field Format from the Format menu. Select the Pop-up lBaist or Pop-up menu style, and then choose Define Value Lists from the pop-up menu of value lists. Calendar, Eventsz 13/3/95{ 29/5/96 Paul Farrah C Education Expense Report 29/5/96{ 29/5/96 Lorraine Smith thoseA threeV timeA time/servicee timecardl titles` today'sH togetheri toolX tools^ total^ trackA trackingK tracks^ traditional` transactionG transactionsG transfer` transportationT travelS treatmentO tripQ tripsQ typeC typesK typicalb unbillablee up-to-dated up-to-the-minutea upcomingH database track frequent flyer milesS database maintain information items haveY track employee leave requestsJ template track collection databaseI usedF usingD listA listedW listsA loanY loan/leaseD loanedY loansT local` maintenanceB makeB makerF makingA manageH manyF meansA medicalO memberH member'sH membersH membershipH menuA messageP mightB mileM mileageS milesS modeA moneyG monthG month'sL monthlyT moreF movesO moviesR muchB multipleB nameJ namesN needF needsE nextH numberA numbersH objectivesQ offersB officeA onceF onlyF orderK organiseB otherA overdueK pageC pastQ pasteC pauseF print@ records@ reflect@ reporting@ roll@ such@ their@ those@ update@ value@ when@ awards certificates@ expenses receipts@ correspondence@ management@ projects@ 29/5/96 Paul Farrah Business Faculty Staff Description You can use this database to maintain school employee data such as hire date, salary, department, and grade. You can also include personal information. How to use this template You can use the Phone Dialling feature to call the employee or the emergency contact person. Click the phone icon beside either field. See the FileMaker Pro documentation for more information about setting up Phone Dialling. How to customise this template You can create a layout that includes your scB hool logo and print faculty identification badges. You could change the field names to customise this database to keep track of employees of any type of business. y#Employee Management, Faculty, Staffz 17/8/95{ 29/5/96 Paul Farrah C Education 29/5/96{ 29/5/96 Lorraine Smith Description This expense-tracking database file is a standard business form for reporting reimbursable business expenses. How to use this template Your employees can enter information directly into the database. Or, they can create a new, blank record, print it, and complete the form by hand. The Report layout has an area for required signatures. How to customise this template Enter your company's per mile reimbursement rate. To do this, choose Define Fields from the File menu, and doub dle-click the Rate per Mile field. Then, change the value in the Data text box. You can create a lookup from the Personnel Records database file based on the Employee ID to enter values for First Name, Last Name, and Extension. By using a lookup, rather than a relation, you keep a record of the personnel data at the time the expense report was created. Employee Management, Expensez 6/3/95 featureI feesH feltQ fieldA fieldsA fileA filemakerE files[ filli fillingi filmR financialE findH finishi finishedF firstJ fixedT flyerS flyingS focusQ followX followed[ following` foodT helpB helpsA hireN historicalO historyK holdO homeR hotelS houseU customise templateI templateE iconN identificationN identifyR Family Medical Records Description This database keeps track of all medical events in your family. Use this database to record pertinent information, such as diagnosis and instructions, to keep a medical history for each family member, and to track insurance billing and payment. How to use this template For each medical event, record the family member, condition, and date. Then use the tabs to enter and view information for the medical provider, treatment, and insurance information. To see a medical history fo 29/5/96{ 29/5/96 Lorraine Smith 29/5/96 Paul Farrah Fax Cover Sheets Description This database provides a simple format to print fax cover sheets. It then keeps track of all cover sheets that have been created. You can use this database to track all faxes that you have sent. How to use this template Simply enter information in the fields and type your message in the scrolling area. When you print the cover sheet using the Fax report, the information is arranged in a standard cover sheet format. You can add your company information and logo to the Fax lay 29/5/96{ 29/5/96 Lorraine Smith r each person in the family, run the Medical History report. How to customise this template Create a separate file to hold information on each of the family's regular medical providers and another one for insurance carriers. Then use lookups to quickly and accurately enter information in the Medical Provider and Insurance areas. By using lookups rather than relations, each record will retain the historical data, even if the doctor moves or the insurance information changes. Doctor, Family, Medicalz 6/3/95 paymentO paymentsD payrolle peopleF performsD personF personalH personalised personnelJ pertinentO phoneH photoR photographU photographs` photos` pictureV picturesV pieceK placeU planQ planningX pop-upA portalP possible` pre-definedA predefinedK preferences[ prepareE presentD previewE priceQ importC import/exportV important[ importingW includeG includedi includesA includingU incomeT individualF informationB inputA insertF instanceB insteadF instructionsO instrumentsY insuranceO integrate_ interestsQ internal` interviewX interviewersX intoC inventoryA invitation^ invited^ invoicee invoice-processingk invoicesK invoicinga 10/3/95{ 29/5/96 Paul Farrah Business Field Trips Description This database maintains information on various field trips. How to use this template You can use the database to record information about past trips, and you can also use it to plan upcoming trips. How to customise this template Create reports that focus on different aspects of the field trips, such as the price, attendance, distance, or interests and objectives. You could also add a field to record whether the field trip supervisor felt that the trip was worth repeating. y,Field Trips, School Administration, Studentsz 30/8/95{ 29/5/96 Paul Farrah C Education Film & Video Library 29/5/96{ 29/5/96 Lorraine Smith How to customise this template If you have a Customers or Contacts database that contains a field for Fax numbers, you can link the To field to the Customer or Contact Name field, and then use the relation to automatically enter the Company and Fax Number. You can also use a relation to display information from the Fax database in your Contacts database. For instance, you can display the dates and subjects of faxes in a portal on a Contacts layout. Correspondence, Facsimile automaticallyP availablea avery] awardsF badgesN balanceG basedA basicF basisE becausee beenP before` beginc beingL belongingsU besideN bidsB billede billingO billingse birthH birthdaysH blankJ booksI borrowedg breaksG briefR browse` budgetT built-in] bureau` businessC buttonF buttonsB calculatee calculatesG calculationH calculationsD callN calledB caller[ camera` candidatesW cardS cardsC carriersO cashE catalogsa cataloguea categoriesA categoryA centre` certificateF coverP createC createdF createsV creating^ creditS creditsG criteriaW currentF currentlyE custom[ customerK customersK customiseA customiseda dataD databaseB databases_ dateA datesP daysH debitS debitsG decisionD defineA definingd deleteE departmentJ dependingg descriptions` designF designatede desired] detailed\ detailingI detailsE 29/5/96 Paul Farrah Frequent Flyer Database Description Use this database to keep track of your frequent flyer miles. How to use this template Enter your frequent flyer transactions into the form. You can keep track of miles you receive from flying or from credit card transactions, hotel stays, and so on. You can also keep track of the miles you redeem, by entering a debit transaction. When you need to know how many frequent flyer miles you have earned, you can use the Mileage Summary report. How to customise this template You caB n track frequent flyer miles for more than one person by adding a name field. You can link this name field to another database using relations. For instance, you might want to keep track of miles for employees or travel agency customers. 29/5/96{ 29/5/96 Lorraine Smith Description Use this database file to keep track of your rolls of film or home video and movies. How to use this template Add your own collection to this database file. Number your rolls of film and videos and include a brief description of what is on the tape or video. How to customise this template You can coordinate this database with the Photo Album database by adding a Film ID field in the Photo Album database to identify the roll of film. In the same way, you can add a Film IDBP field to the Video Library database to add your own home videos to the library. y!Film, Library, Photography, Videoz 6/3/95 whenB frequent flyer miles haveS whereG whetherB whichE wholei willB wineh wine-purchasingh winesh withD withdrawG worke workede worthQ would[ writeG yearsD yes/noB school overdue items report you'llT you're` yourA addressesC administrationQ airlineS airline mileage travelS album` album photography` applicationW application employment assetA asset management insurance inventoryU asset management office inventoryA audio\ audio library music\ awardsF projectsB purchaseb receiptsE recipesc rentalK rolodex] salesk schoolQ searchX servicee sheeta staffN stampsI studentsQ subscriptionH tagsV telephone[ timee timesheetsl trackingi travelS tripsQ vacationJ videoR wedding^ wineh business education skJet 540 Printer Pro 1.0F! Pro 3.0J t US Letter A4 Letter US Legal International Fanfold Computer Paper Envelope (#10) els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12345M1 Airline, Mileage, Travelz 6/3/95{ 29/5/96 Paul Farrah Business Home Budgets Description Use this database to maintain a monthly budget an effective way to control spending and save money. Each month is one record. This template is an example of how to use repeating fields. You could achieve the same result by using one record per entry, with many records in each month. How to use this template Enter your monthly income in the file. Then enter: fixed expenses, such as rent, loans, and insurance essential expenses, such as food and transportation any remai ,ning income to other categories Set up a new budget every month. You'll be able to regularly examine and assess your spending and savings pattern. How to customise this template You can modify the information in the fields for income and expenses by changing the category names and dollar amounts. 29/5/96{ 29/5/96 Lorraine Smith Budgets, Finance, Planningz 7/3/95{ 29/5/96 Paul Farrah Home Inventory Description Use this database file to inventory your belongings, including furniture, jewellery, clothing, artifacts, and heirlooms. The file includes fields for entering the serial number, purchase date, and value of each item. You can also scan and enter a photograph of each item. How to use this template Start by going to each room in your house and list all the items you see. Add as much information as you need to describe each piece. You can print an inventory report and keep it i 29/5/96{ 29/5/96 Lorraine Smith locationA logoC lookC lookupM lookupsO lunchl mailing] maintainN maintainsQ maintenanceB makeB makerF makingA manageH manager_ managing^ manyF matchW meansA medicalO meetingsV memberH member'sH membersH membershipH memoZ memorandumsZ memosZ menuA messageP messages[ microphone` mightB mileM mileageS milesS milestonesi modeA numberA numbersH objectivesQ offersB officeA onceF onlyF orderK organiseB otherA overdueK pageC 29/5/96 Paul Farrah Identification Badges Description Use this file to print out identification such as employee badges, name tags, exposition badges, or place cards. How to use this template Add information about your employees, including digital pictures, if you have them. To add a digital picture, select the photo field and paste the picture from the Clipboard by choosing Paste from the Edit menu, or import a picture from a file by choosing Import/Export from the File menu and then choosing Import Picture You can print ba 29/5/96{ 29/5/96 Lorraine Smith n a safe place, such a a safe-deposit box or with your insurance agent. You can use the information if you have to make an insurance claim. How to customise this template You can modify the value lists for Category and Location fields to suit your particular requirements. Select the field in Layout mode and choose Field Format from the Format menu. Choose Define Value Lists from the pop-up menu of value lists, and modify the list to suit your specific requirements. y,Asset Management, Home, Insurance, Inventoryz 6/3/95 particularU partiesV party^ pastQ pasteC patternT pauseF 29/5/96 Paul Farrah Business Job Application Description Use this form to collect standard applicant information. The form contains fields for an applicant's skills, education, experience, personal information, and references. Simply print the form and use as needed. How to use this template Enter the data from the application form into the database file. You can then search the file to identify all candidates who match specific job criteria. How to customise this template You can modify the form's layout to duplicate your own 29/5/96{ 29/5/96 Lorraine Smith dges, name tags, and place cards by running one of the three reports provided. How to customise this template Add any fields you want to track. For instance, you might want to specify which of your company's sites the employee has access to. You can fully customise the existing layouts or create additional layouts that suit your needs. You can convert this database into one that creates badges and place cards for other purposes, such as parties or professional society meetings. You can also copy layouts from this file to your own personnel database file. In Layout mode, select and copy the graphics of the layout you want to duplicate. In the personnel database, create a new layout and paste in the graphics. Then add the fields you want to use. Badges, ID, Names, Tagsz 6/3/95 spendingT sportingY stagee stampI standardM startH statusf staysS stepF stillk store` storedj studentd studentsY styleL stylesC subjectsP subsummaryG modifyT moment` moneyG monthG month'sL monthlyT moreF mosta movesO movie` moviesR mpgag muchB multi-user[ multipleB musicalY must[ nameJ named[ namesN needF neededW needsE network[ nextH note^ notesX numberA numbersH objectivesQ onceF onlyF options[ orderK ordersb organiseB otherA outstandingY over[ overdueK pageC 29/5/96 Paul Farrah Business Job Search Description Use this database file to develop a job search information database. The file includes fields for planning a job search, contacts, and address information. How to use this template You can enter contact information and any special notes to remind you of the company, the interviewers, and action items. How to customise this template You can add a new layout that includes a thank you letter to follow up on an interview. Choose Layout from the Mode menu, and then choose New LaB yout from the Mode menu. Click the Blank radio button and create a text area using the Text tool. See the FileMaker Pro documentation for information on formatting and adding field information to layout text. Job Search, Employmentz 6/3/95{ 29/5/96 Paul Farrah 29/5/96{ 29/5/96 employee application form. Add your company logo to the Job Application report by copying or importing a picture to the layout. For details on importing a picture, see the FileMaker Pro documentation. Modify the value list for the skills listed on the Skills layout. In Layout mode, select the Skills field in the Skills layout and choose Field Format from the Format menu. In the pop-up menu after "using value list", select Define Value Lists . Edit the list of skills to match those yoC u are seeking. Application, Employment, Jobz 6/3/95 leaseD leaveJ libraryR listf loans managementA medicalO membershipH memorandum messages music\ music database\ names] names addresses] ordersb party^ party wedding planning^ personnel_ personnel records_ photo` photo album` planning^ producta product brochurea projectsi projects systemi purchaseb purchase ordersb receiptsE recipes recordsO rentalK reportM scheduleL searchX servicee sheetsP staffN studentd student recordsd systemi timee service billingse timecards listf formA form'sW formatA formattingX foundF frequentS friends] fromA fronti fullyV furnitureA furtherk futureA generald gifts^ globalF goesG goingU gradeN graphicd graphicallyD graphicsC guardiansd guest^ guests^ handJ hard-to-manageE hardware` haveB headi heirloomsU heldL helpB helpsA hireN historicalO historyK holdO homeR home-schoold hotelS hourse houseU customise templateI identificationN identifyR Memorandum Description This database provides a simple format to print memorandums. It then keeps track of all memos that have been created. You can use this database to track all memos that you have sent. How to use this template Simply enter information in the fields and type your message in the scrolling area. When you print the memo using the Memo report, the information is arranged in a standard memo format. You can add your company information and logo to the Memo layout. How to customise tB his template You can use a relation to display information from the Memo database in your Contacts database. For instance, you can display the dates and subjects of memos in a portal in a Contacts layout. y-Correspondence, Letter Generation, Memorandumz 16/8/95{ 29/5/96 Paul Farrah C Education Messages 29/5/96{ 29/5/96 Loans Description Use this database to maintain information on items that have been loaned, such as software, CDs, books, sporting equipment, and musical instruments. How to use this template You can add your school logo to the Overdue Items report and print an outstanding loan list. How to customise this template You can use a relation to the Students file based on the Borrower ID field to display the First Name and Last Name, eliminating the need for duplicate data entry. y0Equipment, Library, Loans, School Administrationz 22/8/95{ 29/5/96 Paul Farrah C Education reportingM reportsG represents^ requestsJ requiredM requirementsU resourcesi responses^ responsibilityf resultT retainO returni review_ righti runningG safeU safe-depositU salaryN salesb sameF sampled saveT savingsT saysE scanU scanningc scheduleL schoolL screenL scriptF scriptsF scrollingP searchW seekingW selectA send^ sentP separateL serialA serviceB settingN share[ sharing[ sheetP sheetsP showingK signaturesM simpleG simplyE single-user[ sitesV skillsW societyV softwareY someh sortE sortede sortingE sortsE sound` specialX specificU specifyV Music Database Description Use this database file to list your favourite compact discs, tapes, and records. How to use this template Add your own collection to this database file. How to customise this template You can add a container field to the layout and import a picture of the artist or album cover for each album. You can create more detailed reports. For instance, you can summarise your collection by artist or by category. See the FileMaker Pro documentation for more information about Summary leB vels in layouts. Audio, Library, Musicz 6/3/95{ 29/5/96 Paul Farrah Names and Addresses 29/5/96{ 29/5/96 Lorraine Smith 29/5/96 Paul Farrah Business Description Use this database to track your messages. You can use it the same way you would a message pad to record important information about a caller or visitor. How to use this template Anytime a visitor or caller leaves a message, just enter the information into the database and keep track of who needs to be followed up. How to customise this template Create your own custom lists by setting the options for the To field. In Layout mode, select the To field in the Form View layout a nd choose Field Format from the Format menu. Use the Pop-up list style. In the pop-up menu after "using value list", select Define Value Lists . Create a value list named "People" and type the names of the people in your office or home. Share the file over a network. To do this, choose Single-User from the File menu to change the menu item to "Multi-User". You must have chosen a network protocol in the Preferences menu. For more information about sharing files over a network, see the Fi leMaker Pro documentation. Messages, Telephonez 6/3/95 valueA valuesD variousQ verye videoR videosR viewA visitor[ wantB ways` wedding^ whatR HP DeskJet 540 Printer Pro 1.0F! Pro 3.0J t US Letter A4 Letter US Legal International Fanfold Computer Paper Envelope (#10) els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12345M1 13/3/95{ 29/5/96 Paul Farrah Business Party & Wedding Planning Description Use this file to create a database file for guests you have invited to your party or wedding. You can track the number of attendees, gifts received, and notes. How to use this template In this database, each record represents an invitation. You can send one invitation to multiple people, such as a couple or family. You track the number of people addressed in the invitation in the "Attendees" column. The Guest List report tracks the total number of responses. Use the Gifts Re 29/5/96{ 29/5/96 Lorraine Smith Description Use this file to create a database for customers and other contacts, including notes and contact information. The file includes predefined reports for printing customer profiles, phone lists, and mailing labels. How to use this template Use the Notes field to keep information on your contacts and friends, i.e. children's names, birthdays, etc. How to customise this template If the built-in label report does not match the labels you use, edit the existing layout or create a n 9ew layout. To create a new layout, choose Layout from the Mode menu, and then choose New Layout from the Mode menu. Click the Labels radio button and click OK. Choose the desired Avery label number from the pop-up menu and click OK. For details on formatting a label layout, see the FileMaker Pro documentation. Names, Rolodex 29/5/96 Paul Farrah Personnel Records Description You can use this database file to maintain employee data such as hire date, salary, manager, department, pay grade, and next review date. You can also include personal information. How to use this template Use the phone dialling feature to quickly dial the employee's extension. In an emergency, you can click the telephone icon next to the emergency contact information to call the contact person. You can edit your phone dialling preferences in the Preferences dialog box. How tB o customise this template You can create a layout to print employee identification badges. You can also integrate this database with other databases, such as "Expense Reports" using lookups and relations. Employee Management, Personnelz 6/3/95{ 29/5/96 Paul Farrah Business 29/5/96 ceived and Send Thank You Note fields to keep track of gifts and acknowledgements. How to customise this template Create a new layout that is the invitation to your party. Choose Layout from the Mode menu. Choose New Layout from the Mode menu and click the Blank radio button. Design your invitation using the layout tools. For details on creating a new layout, see the FileMaker Pro documentation. If you are managing more than one party at a time, create a new field that will identify whiC!ch party the guest is invited to. y*Event Management, Party, Planning, Weddingz 6/3/95 affectD afterF againstH agencyS agentU albumR allowsk alsoK alwaysa amounte amountsT analyseD anniversariesH anotherO anytime[ applicantW applicant'sW applicationW appropriate` areaM areasO arrangedP arrowi artifactsU artist\ aspectsQ assessT assetA assetsA assignf assignedA attendanceQ attendees^ automatek 29/5/96 Paul Farrah Product Brochure Description This database is used to create a product catalogue that is always up-to-the-minute. By using a database to keep product information, you can create customised catalogs quickly and easily. How to use this template Enter information about your company's product line. You may need to edit the value list for the Category field. In Layout mode, select the Category field in the Form View layout and choose Field Format from the Format menu. In the pop-up menu of value lists, select 29/5/96{ 29/5/96 Lorraine Smith Photo Album Description Use this album to store pictures of family and friends, just like a traditional photo album. You can even include descriptions, titles, QuickTime movies, and sound. How to use this template Before you can start you need to have your photographs in a digital format. The following represents three possible ways: 1. Take your pictures or film to a copy centre or photo lab where they may have the facilities to scan photos or develop your film and save it to disk or CD. 2. Use y 29/5/96 10/3/95 our video camera to record a movie or moment and transfer this to disk. You will need the appropriate hardware and software to do this, or go to a service bureau such as a copy centre or photo lab. See your local computer store for more information. 3. Use a digital camera! Once you have the picture you're ready to start. For details on importing pictures, see the FileMaker Pro documentation. How to customise this template Add a new field called Sound and set the type to Container. C Place this field on the Form View layout. Then enter Browse mode, click in the field, and record a message to go with the picture. In order to record a sound, your computer must have an internal or external microphone. Album, Photography 29/5/96 Paul Farrah Business Purchase Orders Description Use this database file to track purchase orders. FileMaker Pro automatically calculates sales tax and product discounts. How to use this template You can update the sales tax and discount rate by updating the values in those fields. The Purchase Order report prints a typical purchase order form. How to customise this template You can create lookups in this file to your own product database file or even your suppliers' files. A lookup based on Product ID can find information B for Description and Price. A lookup based on Supplier Company can enter information such as the supplier's address and discount rate. Buying, Purchase Ordersz 10/3/95{ 29/5/96 Paul Farrah Business Recipes 29/5/96{ 29/5/96 Lorraine Smith Define Value Lists . Edit the list to contain the values you need. How to customise this template Add the fields that you need for your own company's products. For instance, you might want to keep track of whether or not a product is available. You'll get the most out of this database when you can print all the types of reports you need. Consider creating a profit-margin report, for instance. You can combine this database with an invoicing database to create a complete inventory trackC ing system. Brochure, Product, Data Sheetz 6/3/95 updateb updatedk updatingb database favourite videosg database track those hard-to-manage cashE database track frequent flyer milesS database track collectionh database maintain information items haveY database maintain up-to-date contact informationd track employee leave requestsJ template track collection databaseI usedF usesj usingD vacationl 29/5/96 Paul Farrah Student Records Description Use this database to maintain up-to-date contact information about your students and their parents or guardians. This file includes a sample letter for use in developing home-school connections. The letter is appropriate for keeping parents up-to-date on their child's progress and for relaying general classroom information. How to use this template The sample letter layout includes information for Sunset Elementary School. Insert your own graphic logo and information to per sonalise for your school. For details on importing a picture, see the FileMaker Pro documentation. Enter the student information for your school and you're ready to print out mailing labels and letters. How to customise this template Add your own custom fields to the current layouts or create a new one. For details on creating a new layout or defining new fields, see the FileMaker Pro documentation. Lorraine Smith Description Use this database to keep all your favourite recipes in one place, so they're easy to find and easy to update. How to use this template Click the New Record button and begin entering your recipes. How to customise this template Add a Container field called Picture and add a photo of the finished dish. You can create a digital photo using a digital camera, or by scanning a regular photograph into the computer. Cooking, Food, Recipesz 6/3/95 offersB officeA onceF onlyF openedi options[ orderK ordersb organiseB otherA outstandingY over[ overdueK pageC parentsd correspondenceP correspondence facsimileP correspondence letter generation memorandumZ correspondence letter generation names addresses studentsd dataa doctorO doctor family medicalO employeeJ employee management expenseM employee management faculty staffN employee management leave vacationJ employee management personnel_ employmentW equipmentK equipment library loans school administrationY equipment rentalK event^ event management party planning wedding^ eventsL expenseM expensesE facsimileP facultyN familyO fieldQ field trips school administration studentsQ filmR library photography videoR financeG foodc generationZ homeU insuranceU inventoryA invoicinge search employmentX leaseD leaveJ letterZ libraryI library videog listf organisation loansY 13/3/95{ 29/5/96 Paul Farrah C Education Time & Service Billings Description You can use the Time/Service Billings database to track the amount of time worked and billed against a project for a Customer. Specific activity for each project can be designated for detailed record keeping. How to use this template Each record has both an Hours Worked and an Hours Billed field, because an employee may work unbillable hours (such as during the proposal stage). The employer can run a report to calculate hours worked (for payroll) and hours billed (for accounts $ receivable). How to customise this template This template is very expandable, because it contains information about customers, employees, projects, and accounting. You can link to invoices for billing, create reports sorted by activity or by invoice, track employee productivity, and so on. 29/5/96{ 29/5/96 Lorraine Smith y=Correspondence, Letter Generation, Names, Addresses, Students determineD developX developingd diagnosisO dial_ diallingN dialog_ y!Billing, Invoicing, Time, Servicez 6/3/95{ 29/5/96 Paul Farrah Business To Do List Description You can use the To Do list database file to organise, track, and assign responsibility for tasks. How to use this template Click one of the Sort icons in the View as List layout to sort tasks by date, priority, item, or status. How to customise this template You can add a Name field to the List layout to assign a task to a specific person. You can also share the file over a network. List, Organisation, To Doz 6/3/95{ 29/5/96 Paul Farrah C Education Video Database 29/5/96{ 29/5/96 Lorraine Smith 29/5/96 Paul Farrah Wine Cellar vDescription Use this database to keep track of your wine collection. How to use this template Add information about the wines in your cellar. How to customise this template Add a field to designate whether you currently own the wine or would like to purchase some in the future. Then, create a report of your desired acquisitions to use on your next wine-purchasing trip. Beverages, Cellar, Winez 22/3/95{ 29/5/96 Paul Farrah Projects System 29/5/96{ 29/5/96 Lorraine Smith Description Use this database file to list your favourite videos. How to use this template Add your own collection to the file. You can sort the collection in various ways, depending on your needs. For instance, you can search for Action movies, or list them by MPGA rating (G, PG, and so on). How to customise this template You can add a comment field to the layout and add comments. Or, add a field to track who has borrowed each video. Library, Videoz 7/4/95 theirA themH thenC thesei theyF they'rec thisA database maintains information various field tripsQ helps track rental equipment furnitureK depositG depreciableA describeU description descriptions` designF designateh designatede desired] detailed\ detailingI detailsE borrowerY bothe breaksG briefR broughti browse` budgetT built-in] bureau` businessC buttonF buttonsB calculatee calculatesG calculationH calculationsD callN calledB caller[ camera` candidatesW cardS cardsC carriersO cashE catalogsa cataloguea categoriesA categoryA cellarh centre` certificateF templateE iconN iconsf identificationN identifyR 29/5/96 Paul Farrah Business Expenses System Description This expense-tracking database consists of three related database files. The Employee Expenses file uses a standard business form for reporting reimbursable business expenses. The line items are stored in the Expense Line Items database file. Employee information is stored in the Employee Names file. How to use this template Your employees can enter information directly into the Employee Expenses database. Or, they can create a new, blank record, print it, and complete the forB m by hand. The Report layout has an area for required signatures. How to customise this template Create your own custom reports, and define the expense categories your company uses. y%Expense Tracking, Employee Managementz 24/10/95{ 29/5/96 Paul Farrah Business 29/5/96{ 29/5/96 Description This relational database template consists of the Projects file and the Project Tasks file. These two database files work together to keep track of projects and the specific tasks that need to be accomplished to complete each project. The Projects file keeps track of general information such as project name, status, description, milestones, and resources. The Project Tasks file contains details about the specific tasks, such as the task's status, cost, and head count. How to use this template Start by defining the whole project in the Projects database. Then, name each task and fill out as much of the other information as you know. If you click the arrow button to the right of the task information, the Project Tasks database is opened and brought to the front. Finish filling out the task information, and then click the arrow button to the right of the Project Name to return to the Projects file. How to customise this template You can create custom reports to Horganise the data. For instance, the report layout included in the Project Tasks file shows the tasks for each person on the team. You might want to organise the tasks by date or status. If you have a regular team, you might want to use a value list to help you enter their names in the Task Manager and Project Manager fields. Project Management, Trackingz 24/10/95 rollR rollsR roomU runningG safeU safe-depositU salaryN salesb sameF sampled saveT savingsT saysE scanU scanningc scheduleL schoolL screenL scriptF scriptsF scrollingP searchW seekingW selectA send^ sentP separateL serialA serviceB servicesk settingN share[ sharing[ sheetP sheetsP showingK showsi sickl signaturesM simpleG simplyE single-user[ sitesV skillsW societyV softwareY someh sortE sortede sortingE sortsE sound` specialX specificU specifyV spending@ such@ their@ those@ update@ value@ when@ awards certificates@ expenses receipts@ correspondence@ expense tracking employee management@ management@ projects@ expense tracking employee managementj expensesE facsimileP facultyN familyO fieldQ field trips school administration studentsQ filmR library photography videoR financeG finance payroll timesheetsl foodc generationZ homeU insuranceU inventoryA invoicinge search employmentX leaseD leaveJ letterZ libraryI library videog listf organisation loansY ,Y Timecards Description This database keeps track of employee hours, and is based on the standard employee timecard. How to use this template Your employees can enter their hours directly into the database, or you can print blank Timecard reports for them to fill out and return. The database calculates the hours worked based on the start time, lunch duration, and end time. How to customise this template You can add fields to calculate the employee's pay, based on the hours they worked and their paBfy rate. You can also track vacation and sick time, by adding a summary field for each time category. y"Finance, Payroll, Time, Timesheetsz 24/10/95{ 29/5/96 Paul Farrah Business Inventory System Description This relational database consists of three files that help you track product inventory and sales. The product information is created and stored in the Product Inventory file. The Product Sales file tracks customer invoices. The line items for an invoice are created in the Product Sales file but are stored in the Line Items file. How to use this template First, enter the product information in the Product Inventory file. Then you can create invoices in the Product Sales that us 29/5/96{ 29/5/96 29/5/96 Paul Farrah Business e data from the Product Inventory file, such as the product description and cost. The individual line items of each invoice are stored in the Line Items file, which allows you to do detailed reporting on your sales. After an invoice is created, the Product Inventory file is updated to reflect the reduced inventory. How to customise this template You might use still another relation to store information about frequent customers. This information would be used in the Product Sales file to fC{urther automate invoice-processing. You can also add fields and edit value lists to reflect your own products and services. y5Billing, Invoicing, Sales, Inventory Control, Productz 24/10/95 earnedS easierA easilyC easyB editA editingC educationW effectiveT eitherN elementaryd eliminatingY emailH emergencyN employeeJ employee's_ employeesJ employere enterA enter information fields yourI enter frequent flyer transactions enteringS !oose New from the File menu. FileMaker Pro makes a copy of the original template and opens the copy for you to use. Modifications are then made to the new database, not the original template. To open a database you have created, select Open from the File menu and select the desired file. Welcome! Included with FileMaker Pro is a collection of templates to help you begin using the product quickly. These templates are designed as solutions for either business, education, or home use and may give you new ideas about how to use FileMaker Pro. All templates are available on the FileMaker Pro CD installation, with a reduced set included on the floppy disk installation. The templates are relatively simple and can be easily modified to suit your own needs. Just add or modify fi elds, layouts, or scripts when necessary. If you are new to FileMaker Pro, review the documentation and the FileMaker Pro Tutorial (included with the product) for more information on working with FileMaker Pro files. Select a category of templates from the buttons provided to see an overview of the FileMaker Pro templates and what they can do for you! To create a database using a template, select a template from the New Database dialog box that appears when you start FileMaker Pro or ch 1996 Claris Corp. FileMaker is a registered trademark of Claris Corporation. Project Management Tony Campitelli Software Development Paul Farrah Graphic Design German Bauer Documentation Kathy Osborne Special Thanks to Brian Ballek, Alex Broquet, Michael DeNardi, Michael Ellard, Dave Heiber, Jennifer Henderson, Rob McCullough, John Phelan, Keith Proctor, Jamie Pruden, Don Ross, Bill Shissler, Joanna Terry, and the entire FileMaker team. sed by clicking buttons in the button bar located at the top of each layout in the template files. Form View To access the Form View layout, click the View as Form button in the button bar. Use the Form View layout to enter data into the template file. Each sample solution with data consists of at least one Form View layout that contains all the information pertaining to a record. If more than one Form View layout is included in a solution (e.g. in the Job Application database), tabs have been provided to easily navigate between screens while still working with the same record. List View To access the List View layout, click the View as List button in the button bar. The List View is used to display multiple records onscreen simultaneously. This differs from the Form View, which displays one record at a time. Information To access the Information layout, click the Info button in the button bar. This layout contains a brief description of the file, an explanation of how t o use it, and suggestions for customising it for your own needs. Report Menu To access the Report Menu, click the Reports button in the button bar. The Report Menu layout contains at least four buttons. Some of these have already been defined, with the others left for your use. When you click one of the named report buttons, the solution automatically switches to the corresponding report layout and pauses in Preview mode so that you can see what the report will look like when it prints. To print the report, choose Print from the File menu while the report is paused in Preview mode. Click the Continue button to return to the Report Menu. Creating Custom Buttons and Reports Creating Your Own Buttons Each FileMaker Pro template contains at least one button labelled "Your Own Button" on most layouts. Use this button as a shortcut to perform a common task. For example, you may want to create a button that prints the current record. To define a Print button: 1. Choose Layou t from the Mode menu. 2. Select the button labelled Your Own Button. 3. Choose Button... from the Format menu. 4. Select Print from the list of commands. 5. Click OK to close the dialog box. 6. Change the button text to "Print" by selecting the button text "Your Own Button," typing the word "Print," and pressing the Enter key. 7. Choose Browse from the Mode menu. 8. Click your new button and watch the Print dialog box appear! Note: To execute multiple commands by simply click ing a button, you can attach a ScriptMaker script to the button. For details on creating scripts and buttons, see chapter 5, "Using ScriptMaker and Buttons," in the FileMaker Pro User's Guide. Creating Your Own Reports The Reports Menu layout contains a button labelled "Your Own Report", that can be customised to display your own reports. Use this button as a shortcut. For example, you may wish to create a button that finds all your contacts in California, sorts them by Last Name, and pr ints a report. 1. Create a layout that contains the fields you want on your report. For details on creating layouts for reports, see chapter 3, "Laying Out and Arranging Information," in the FileMaker Pro User's Guide. 2. Create a script that finds the records you want, sorts, goes to the new report layout, and previews the report. Use the following script steps to accomplish this: Perform Find, Sort, Go to Layout, and Enter Preview Mode For details o n creating scripts, see chapter 5, "Using ScriptMaker and Buttons," in the FileMaker Pro User's Guide. 3. In Layout mode, select the button named "Your Own Report." 4. Choose Button... from the Format menu. 5. Select Perform Script from the list of commands. 6. Choose the script that you defined in step 2 from the Specify Script pop-up menu. 7. Click OK to close the dialog box. 8. Change the text for this button by clicking the text "Your Own Report," typing the name of your re port, and pressing the Enter key. 9. Choose Browse from the Mode menu. 10. Click your new report button to see the report! Note: For information on printing reports, see chapter 6, "Previewing and Printing Information," in the FileMaker Pro User's Guide. Examples with Data Also included on the FileMaker Pro CD are copies of the template examples that include data, to allow you to see how the templates work. These files are located in the Examples folder in the FileMaker PrL o folder.